package com.trkj.dao.jpa;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojos.Tbrole;

public interface IHwcRoleDAO extends CrudRepository<Tbrole, Long> {
	
	/**
	 * 获取所有角色
	 */
	@Query("select new Tbrole(r.roleNo,r.roleName,r.roleExplain) from Tbrole r where r.roleNo!=9999")
	public List<Tbrole> queryAllTbRole();
	
}
